package com.rfsp.common.mapper;


import java.util.List;

import com.rfsp.common.base.BaseMapper;
import com.rfsp.common.pojo.po.AreaPO;
import com.rfsp.common.pojo.vo.AreaVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface AreaMapper extends BaseMapper<AreaPO> {
	
	
	public List<AreaVO> getAreaTree(String uppCode);
	
	/**
	 * 根据areaCode获取AreaCodePO对象
	 * @param areaCode
	 * @return
	 */
	public AreaPO getAreaByCode(String areaCode);


    @Select("select AREANAME text, AREACODE ID, UPPRCODE parent from m_dd_areacode t order by t.AREACODE asc")
    public List<AreaVO> queryAll();
    
}
